Tabela DrugProducer

Definicja tabeli DrugProducer

Name

DrugProducer

Code

DrugProducer

Comment

Slownik producentów leków


Lista kolumn tabeli DrugProducer

Name

Code

DrugProducerID

DrugProducerID

Name

Name

PolishName

PolishName

Address

Address

City

City

Phone

Phone

Fax

Fax

Email

Email

www

www

Notes

Notes

HashCode

HashCode

LastModifiedDT

LastModifiedDT


Kolumna DrugProducerID tabeli DrugProducer

Definicja kolumny DrugProducerID tabeli DrugProducer

Name

DrugProducerID

Code

DrugProducerID

Data Type

VARCHAR2(6)

Mandatory

Yes

Comment

 


Kolumna Name tabeli DrugProducer

Definicja kolumny Name tabeli DrugProducer

Name

Name

Code

Name

Data Type

VARCHAR2(128)

Mandatory

No

Comment

 


Kolumna PolishName tabeli DrugProducer

Definicja kolumny PolishName tabeli DrugProducer

Name

PolishName

Code

PolishName

Data Type

VARCHAR2(128)

Mandatory

No

Comment

 


Kolumna Address tabeli DrugProducer

Definicja kolumny Address tabeli DrugProducer

Name

Address

Code

Address

Data Type

VARCHAR2(60)

Mandatory

No

Comment

 


Kolumna City tabeli DrugProducer

Definicja kolumny City tabeli DrugProducer

Name

City

Code

City

Data Type

VARCHAR2(60)

Mandatory

No

Comment

 


Kolumna Phone tabeli DrugProducer

Definicja kolumny Phone tabeli DrugProducer

Name

Phone

Code

Phone

Data Type

VARCHAR2(60)

Mandatory

No

Comment

 


Kolumna Fax tabeli DrugProducer

Definicja kolumny Fax tabeli DrugProducer

Name

Fax

Code

Fax

Data Type

VARCHAR2(30)

Mandatory

No

Comment

 


Kolumna Email tabeli DrugProducer

Definicja kolumny Email tabeli DrugProducer

Name

Email

Code

Email

Data Type

VARCHAR2(50)

Mandatory

No

Comment

 


Kolumna www tabeli DrugProducer

Definicja kolumny www tabeli DrugProducer

Name

www

Code

www

Data Type

VARCHAR2(50)

Mandatory

No

Comment

 


Kolumna Notes tabeli DrugProducer

Definicja kolumny Notes tabeli DrugProducer

Name

Notes

Code

Notes

Data Type

CLOB

Mandatory

No

Comment

 


Kolumna HashCode tabeli DrugProducer

Definicja kolumny HashCode tabeli DrugProducer

Name

HashCode

Code

HashCode

Data Type

VARCHAR2(32)

Mandatory

No

Comment

Kod MD5 tworzony na podstawie danych z wszystkich kolumn tabeli


Kolumna LastModifiedDT tabeli DrugProducer

Definicja kolumny LastModifiedDT tabeli DrugProducer

Name

LastModifiedDT

Code

LastModifiedDT

Data Type

DATE

Mandatory

No

Comment

Data ostatniej modyfikacji


Lista kluczy tabeli DrugProducer

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli DrugProducer

Definicja klucza Identifier_1 tabeli DrugProducer

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment